﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ExactDS" targetNamespace="http://tempuri.org/ExactDS.xsd" xmlns:mstns="http://tempuri.org/ExactDS.xsd" xmlns="http://tempuri.org/ExactDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="_200ConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="_200ConnectionString2 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Exact_Extension.Properties.Settings.GlobalReference.Default._200ConnectionString2" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ISHCMC_DiscountTableAdapter" GeneratorDataComponentClassName="ISHCMC_DiscountTableAdapter" Name="ISHCMC_Discount" UserDataComponentName="ISHCMC_DiscountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_200ConnectionString2 (Settings)" DbObjectName="[300].dbo.ISHCMC_Discount" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ISHCMC_Discount] WHERE (([ID] = @Original_ID) AND ([Debcode] = @Original_Debcode) AND ((@IsNull_StudentID = 1 AND [StudentID] IS NULL) OR ([StudentID] = @Original_StudentID)) AND ((@IsNull_ADF = 1 AND [ADF] IS NULL) OR ([ADF] = @Original_ADF)) AND ((@IsNull_APP = 1 AND [APP] IS NULL) OR ([APP] = @Original_APP)) AND ((@IsNull_TuitionFee = 1 AND [TuitionFee] IS NULL) OR ([TuitionFee] = @Original_TuitionFee)) AND ((@IsNull_TeacherKid = 1 AND [TeacherKid] IS NULL) OR ([TeacherKid] = @Original_TeacherKid)) AND ((@IsNull_Sibling = 1 AND [Sibling] IS NULL) OR ([Sibling] = @Original_Sibling)) AND ((@IsNull_FivePlus = 1 AND [FivePlus] IS NULL) OR ([FivePlus] = @Original_FivePlus)) AND ((@IsNull_SpecialCase = 1 AND [SpecialCase] IS NULL) OR ([SpecialCase] = @Original_SpecialCase)) AND ((@IsNull_CCC = 1 AND [CCC] IS NULL) OR ([CCC] = @Original_CCC)) AND ((@IsNull_ThirdChild = 1 AND [ThirdChild] IS NULL) OR ([ThirdChild] = @Original_ThirdChild)) AND ((@IsNull_Silver = 1 AND [Silver] IS NULL) OR ([Silver] = @Original_Silver)) AND ((@IsNull_Gold = 1 AND [Gold] IS NULL) OR ([Gold] = @Original_Gold)) AND ((@IsNull_Platium = 1 AND [Platium] IS NULL) OR ([Platium] = @Original_Platium)) AND ((@IsNull_Remark = 1 AND [Remark] IS NULL) OR ([Remark] = @Original_Remark)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_APP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_APP" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuitionFee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TeacherKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sibling" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FivePlus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SpecialCase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThirdChild" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Silver" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gold" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Platium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Remark" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ISHCMC_Discount] ([Debcode], [StudentID], [ADF], [APP], [TuitionFee], [TeacherKid], [Sibling], [FivePlus], [SpecialCase], [CCC], [ThirdChild], [Silver], [Gold], [Platium], [Remark]) VALUES (@Debcode, @StudentID, @ADF, @APP, @TuitionFee, @TeacherKid, @Sibling, @FivePlus, @SpecialCase, @CCC, @ThirdChild, @Silver, @Gold, @Platium, @Remark);
SELECT ID, Debcode, StudentID, ADF, APP, TuitionFee, TeacherKid, Sibling, FivePlus, SpecialCase, CCC, ThirdChild, Silver, Gold, Platium, Remark FROM ISHCMC_Discount WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@APP" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Debcode, StudentID, ADF, APP, TuitionFee, TeacherKid, Sibling, FivePlus, SpecialCase, CCC, ThirdChild, Silver, Gold, Platium, Remark FROM dbo.ISHCMC_Discount</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ISHCMC_Discount] SET [Debcode] = @Debcode, [StudentID] = @StudentID, [ADF] = @ADF, [APP] = @APP, [TuitionFee] = @TuitionFee, [TeacherKid] = @TeacherKid, [Sibling] = @Sibling, [FivePlus] = @FivePlus, [SpecialCase] = @SpecialCase, [CCC] = @CCC, [ThirdChild] = @ThirdChild, [Silver] = @Silver, [Gold] = @Gold, [Platium] = @Platium, [Remark] = @Remark WHERE (([ID] = @Original_ID) AND ([Debcode] = @Original_Debcode) AND ((@IsNull_StudentID = 1 AND [StudentID] IS NULL) OR ([StudentID] = @Original_StudentID)) AND ((@IsNull_ADF = 1 AND [ADF] IS NULL) OR ([ADF] = @Original_ADF)) AND ((@IsNull_APP = 1 AND [APP] IS NULL) OR ([APP] = @Original_APP)) AND ((@IsNull_TuitionFee = 1 AND [TuitionFee] IS NULL) OR ([TuitionFee] = @Original_TuitionFee)) AND ((@IsNull_TeacherKid = 1 AND [TeacherKid] IS NULL) OR ([TeacherKid] = @Original_TeacherKid)) AND ((@IsNull_Sibling = 1 AND [Sibling] IS NULL) OR ([Sibling] = @Original_Sibling)) AND ((@IsNull_FivePlus = 1 AND [FivePlus] IS NULL) OR ([FivePlus] = @Original_FivePlus)) AND ((@IsNull_SpecialCase = 1 AND [SpecialCase] IS NULL) OR ([SpecialCase] = @Original_SpecialCase)) AND ((@IsNull_CCC = 1 AND [CCC] IS NULL) OR ([CCC] = @Original_CCC)) AND ((@IsNull_ThirdChild = 1 AND [ThirdChild] IS NULL) OR ([ThirdChild] = @Original_ThirdChild)) AND ((@IsNull_Silver = 1 AND [Silver] IS NULL) OR ([Silver] = @Original_Silver)) AND ((@IsNull_Gold = 1 AND [Gold] IS NULL) OR ([Gold] = @Original_Gold)) AND ((@IsNull_Platium = 1 AND [Platium] IS NULL) OR ([Platium] = @Original_Platium)) AND ((@IsNull_Remark = 1 AND [Remark] IS NULL) OR ([Remark] = @Original_Remark)));
SELECT ID, Debcode, StudentID, ADF, APP, TuitionFee, TeacherKid, Sibling, FivePlus, SpecialCase, CCC, ThirdChild, Silver, Gold, Platium, Remark FROM ISHCMC_Discount WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@APP" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_APP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_APP" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuitionFee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TeacherKid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sibling" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FivePlus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SpecialCase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThirdChild" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Silver" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gold" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Platium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Remark" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Debcode" DataSetColumn="Debcode" />
              <Mapping SourceColumn="StudentID" DataSetColumn="StudentID" />
              <Mapping SourceColumn="ADF" DataSetColumn="ADF" />
              <Mapping SourceColumn="APP" DataSetColumn="APP" />
              <Mapping SourceColumn="TuitionFee" DataSetColumn="TuitionFee" />
              <Mapping SourceColumn="TeacherKid" DataSetColumn="TeacherKid" />
              <Mapping SourceColumn="Sibling" DataSetColumn="Sibling" />
              <Mapping SourceColumn="FivePlus" DataSetColumn="FivePlus" />
              <Mapping SourceColumn="SpecialCase" DataSetColumn="SpecialCase" />
              <Mapping SourceColumn="CCC" DataSetColumn="CCC" />
              <Mapping SourceColumn="ThirdChild" DataSetColumn="ThirdChild" />
              <Mapping SourceColumn="Silver" DataSetColumn="Silver" />
              <Mapping SourceColumn="Gold" DataSetColumn="Gold" />
              <Mapping SourceColumn="Platium" DataSetColumn="Platium" />
              <Mapping SourceColumn="Remark" DataSetColumn="Remark" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="_200ConnectionString2 (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[ISHCMC_Discount] ([Debcode], [StudentID], [ADF], [APP], [TuitionFee], [TeacherKid], [Sibling], [FivePlus], [SpecialCase], [CCC], [ThirdChild], [Silver], [Gold], [Platium], [Remark]) VALUES (@Debcode, @StudentID, @ADF, @APP, @TuitionFee, @TeacherKid, @Sibling, @FivePlus, @SpecialCase, @CCC, @ThirdChild, @Silver, @Gold, @Platium, @Remark);
SELECT ID, Debcode, StudentID, ADF, APP, TuitionFee, TeacherKid, Sibling, FivePlus, SpecialCase, CCC, ThirdChild, Silver, Gold, Platium, Remark FROM ISHCMC_Discount WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Debcode" ColumnName="Debcode" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentID" ColumnName="StudentID" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ADF" ColumnName="ADF" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="APP" ColumnName="APP" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@APP" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TuitionFee" ColumnName="TuitionFee" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TeacherKid" ColumnName="TeacherKid" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Sibling" ColumnName="Sibling" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FivePlus" ColumnName="FivePlus" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SpecialCase" ColumnName="SpecialCase" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CCC" ColumnName="CCC" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ThirdChild" ColumnName="ThirdChild" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Silver" ColumnName="Silver" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Gold" ColumnName="Gold" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Platium" ColumnName="Platium" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Remark" ColumnName="Remark" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="nvarchar(500)" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="_200ConnectionString2 (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[ISHCMC_Discount] SET [Debcode] = @Debcode, [StudentID] = @StudentID, [ADF] = @ADF, [APP] = @APP, [TuitionFee] = @TuitionFee, [TeacherKid] = @TeacherKid, [Sibling] = @Sibling, [FivePlus] = @FivePlus, [SpecialCase] = @SpecialCase, [CCC] = @CCC, [ThirdChild] = @ThirdChild, [Silver] = @Silver, [Gold] = @Gold, [Platium] = @Platium, [Remark] = @Remark WHERE (([ID] = @Original_ID));
SELECT ID, Debcode, StudentID, ADF, APP, TuitionFee, TeacherKid, Sibling, FivePlus, SpecialCase, CCC, ThirdChild, Silver, Gold, Platium, Remark FROM ISHCMC_Discount WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Debcode" ColumnName="Debcode" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Debcode" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Debcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentID" ColumnName="StudentID" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ADF" ColumnName="ADF" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@ADF" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="ADF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="APP" ColumnName="APP" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@APP" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="APP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TuitionFee" ColumnName="TuitionFee" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TuitionFee" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TuitionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TeacherKid" ColumnName="TeacherKid" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TeacherKid" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TeacherKid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Sibling" ColumnName="Sibling" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Sibling" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Sibling" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FivePlus" ColumnName="FivePlus" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@FivePlus" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="FivePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SpecialCase" ColumnName="SpecialCase" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@SpecialCase" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="SpecialCase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CCC" ColumnName="CCC" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@CCC" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="CCC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ThirdChild" ColumnName="ThirdChild" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@ThirdChild" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="ThirdChild" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Silver" ColumnName="Silver" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Silver" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Silver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Gold" ColumnName="Gold" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Gold" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Gold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Platium" ColumnName="Platium" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="numeric(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Platium" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Platium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Remark" ColumnName="Remark" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="nvarchar(500)" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ID" ColumnName="ID" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[300].dbo.ISHCMC_Discount" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ExactDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="ExactDS" msprop:Generator_UserDSName="ExactDS">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ISHCMC_Discount" msprop:Generator_TableClassName="ISHCMC_DiscountDataTable" msprop:Generator_TableVarName="tableISHCMC_Discount" msprop:Generator_RowChangedName="ISHCMC_DiscountRowChanged" msprop:Generator_TablePropName="ISHCMC_Discount" msprop:Generator_RowDeletingName="ISHCMC_DiscountRowDeleting" msprop:Generator_RowChangingName="ISHCMC_DiscountRowChanging" msprop:Generator_RowEvHandlerName="ISHCMC_DiscountRowChangeEventHandler" msprop:Generator_RowDeletedName="ISHCMC_DiscountRowDeleted" msprop:Generator_RowClassName="ISHCMC_DiscountRow" msprop:Generator_UserTableName="ISHCMC_Discount" msprop:Generator_RowEvArgName="ISHCMC_DiscountRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Debcode" msprop:Generator_ColumnVarNameInTable="columnDebcode" msprop:Generator_ColumnPropNameInRow="Debcode" msprop:Generator_ColumnPropNameInTable="DebcodeColumn" msprop:Generator_UserColumnName="Debcode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentID" msprop:Generator_ColumnVarNameInTable="columnStudentID" msprop:Generator_ColumnPropNameInRow="StudentID" msprop:Generator_ColumnPropNameInTable="StudentIDColumn" msprop:Generator_UserColumnName="StudentID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ADF" msprop:Generator_ColumnVarNameInTable="columnADF" msprop:Generator_ColumnPropNameInRow="ADF" msprop:Generator_ColumnPropNameInTable="ADFColumn" msprop:Generator_UserColumnName="ADF" type="xs:decimal" minOccurs="0" />
              <xs:element name="APP" msprop:Generator_ColumnVarNameInTable="columnAPP" msprop:Generator_ColumnPropNameInRow="APP" msprop:Generator_ColumnPropNameInTable="APPColumn" msprop:Generator_UserColumnName="APP" type="xs:decimal" minOccurs="0" />
              <xs:element name="TuitionFee" msprop:Generator_ColumnVarNameInTable="columnTuitionFee" msprop:Generator_ColumnPropNameInRow="TuitionFee" msprop:Generator_ColumnPropNameInTable="TuitionFeeColumn" msprop:Generator_UserColumnName="TuitionFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="TeacherKid" msprop:Generator_ColumnVarNameInTable="columnTeacherKid" msprop:Generator_ColumnPropNameInRow="TeacherKid" msprop:Generator_ColumnPropNameInTable="TeacherKidColumn" msprop:Generator_UserColumnName="TeacherKid" type="xs:decimal" minOccurs="0" />
              <xs:element name="Sibling" msprop:Generator_ColumnVarNameInTable="columnSibling" msprop:Generator_ColumnPropNameInRow="Sibling" msprop:Generator_ColumnPropNameInTable="SiblingColumn" msprop:Generator_UserColumnName="Sibling" type="xs:decimal" minOccurs="0" />
              <xs:element name="FivePlus" msprop:Generator_ColumnVarNameInTable="columnFivePlus" msprop:Generator_ColumnPropNameInRow="FivePlus" msprop:Generator_ColumnPropNameInTable="FivePlusColumn" msprop:Generator_UserColumnName="FivePlus" type="xs:decimal" minOccurs="0" />
              <xs:element name="SpecialCase" msprop:Generator_ColumnVarNameInTable="columnSpecialCase" msprop:Generator_ColumnPropNameInRow="SpecialCase" msprop:Generator_ColumnPropNameInTable="SpecialCaseColumn" msprop:Generator_UserColumnName="SpecialCase" type="xs:decimal" minOccurs="0" />
              <xs:element name="CCC" msprop:Generator_ColumnVarNameInTable="columnCCC" msprop:Generator_ColumnPropNameInRow="CCC" msprop:Generator_ColumnPropNameInTable="CCCColumn" msprop:Generator_UserColumnName="CCC" type="xs:decimal" minOccurs="0" />
              <xs:element name="ThirdChild" msprop:Generator_ColumnVarNameInTable="columnThirdChild" msprop:Generator_ColumnPropNameInRow="ThirdChild" msprop:Generator_ColumnPropNameInTable="ThirdChildColumn" msprop:Generator_UserColumnName="ThirdChild" type="xs:decimal" minOccurs="0" />
              <xs:element name="Silver" msprop:Generator_ColumnVarNameInTable="columnSilver" msprop:Generator_ColumnPropNameInRow="Silver" msprop:Generator_ColumnPropNameInTable="SilverColumn" msprop:Generator_UserColumnName="Silver" type="xs:decimal" minOccurs="0" />
              <xs:element name="Gold" msprop:Generator_ColumnVarNameInTable="columnGold" msprop:Generator_ColumnPropNameInRow="Gold" msprop:Generator_ColumnPropNameInTable="GoldColumn" msprop:Generator_UserColumnName="Gold" type="xs:decimal" minOccurs="0" />
              <xs:element name="Platium" msprop:Generator_ColumnVarNameInTable="columnPlatium" msprop:Generator_ColumnPropNameInRow="Platium" msprop:Generator_ColumnPropNameInTable="PlatiumColumn" msprop:Generator_UserColumnName="Platium" type="xs:decimal" minOccurs="0" />
              <xs:element name="Remark" msprop:Generator_ColumnVarNameInTable="columnRemark" msprop:Generator_ColumnPropNameInRow="Remark" msprop:Generator_ColumnPropNameInTable="RemarkColumn" msprop:Generator_UserColumnName="Remark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ISHCMC_Discount" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>